﻿CREATE PROCEDURE [dbo].[InvoiceByPerson]
@BeginDate DATETIME, @EndDate DATETIME
AS
SELECT FullName, Project, EntryDate, Duration, HourlyRate, Duration * HourlyRate AS Billing, Category, Description
FROM  dbo.vwInvoices
WHERE (EntryDate >= @BeginDate) AND (EntryDate <= @EndDate)
ORDER BY FullName, Project, EntryDate

